﻿package com.fandy.struts.SqlStatement;

public class sellinfo {
 
	public   String  getAll()
	{
		return   "select * from sellinfo";
	}
	
	public   String getSellInfoByDepID(int departmentID)
	{
		return  "select * from sellinfo where " +com.fandy.struts.Meta.sellinfo.getDepartmentid()+"="+departmentID;
	}
	
	
	public   String getSellInfoByStaffID(int StaffID)
	{
		return  "select * from sellinfo where " +com.fandy.struts.Meta.sellinfo.getGoodsid()+"="+StaffID;
	}
	
	public   String getSellInfoByMagID(int ManagerID)
	{
		return  "select * from sellinfo where " +com.fandy.struts.Meta.sellinfo.getManagerid()+"="+ManagerID;
	}
	
	public   String getSellInfoByGoodsID(int GoodsID)
	{
		return  "select * from sellinfo where " +com.fandy.struts.Meta.sellinfo.getGoodsid()+"="+GoodsID;
	}



}

